Tabela PhBlockade

Definicja tabeli PhBlockade

Name

PhBlockade

Code

PhBlockade

Comment

Blokady leków i dostaw


Lista kolumn tabeli PhBlockade

Name

Code

BlockadeID

BlockadeID

StItemID

StItemID

BlockadeDT

BlockadeDT

Info

Info

Automatic

Automatic

UnlockDT

UnlockDT

BlockadeTypeID

BlockadeTypeID

BlockadeNo

BlockadeNo


Kolumna BlockadeID tabeli PhBlockade

Definicja kolumny BlockadeID tabeli PhBlockade

Name

BlockadeID

Code

BlockadeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StItemID tabeli PhBlockade

Definicja kolumny StItemID tabeli PhBlockade

Name

StItemID

Code

StItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BlockadeDT tabeli PhBlockade

Definicja kolumny BlockadeDT tabeli PhBlockade

Name

BlockadeDT

Code

BlockadeDT

Data Type

DATE

Mandatory

No

Comment

Data blokady


Kolumna Info tabeli PhBlockade

Definicja kolumny Info tabeli PhBlockade

Name

Info

Code

Info

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Informacja o powodzie wycofania danej serii


Kolumna Automatic tabeli PhBlockade

Definicja kolumny Automatic tabeli PhBlockade

Name

Automatic

Code

Automatic

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Mówi o tym, czy blokada byla tworzona przez system automatycznie


Kolumna UnlockDT tabeli PhBlockade

Definicja kolumny UnlockDT tabeli PhBlockade

Name

UnlockDT

Code

UnlockDT

Data Type

DATE

Mandatory

No

Comment

Data anulowania blokady


Kolumna BlockadeTypeID tabeli PhBlockade

Definicja kolumny BlockadeTypeID tabeli PhBlockade

Name

BlockadeTypeID

Code

BlockadeTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Typ blokady


Kolumna BlockadeNo tabeli PhBlockade

Definicja kolumny BlockadeNo tabeli PhBlockade

Name

BlockadeNo

Code

BlockadeNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer blokady


Lista kluczy tabeli PhBlockade

Name

Code

Primary

Key_1

Key_1

X


Klucz Key_1 tabeli PhBlockade

Definicja klucza Key_1 tabeli PhBlockade

Name

Key_1

Code

Key_1

Primary

Yes

Comment